package com.sz.mes.excel.model;

import java.util.Date;
import java.lang.Double;
import java.math.BigDecimal;

import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.TableField;
import com.diboot.core.util.D;
import com.diboot.file.excel.BaseExcelModel;
import lombok.Getter;
import lombok.Setter;
import javax.validation.constraints.NotNull;

import com.sz.mes.entity.RequestPurchase;
import org.hibernate.validator.constraints.Length;

/**
* 请购订单 导出model定义
* @author hem
* @version 1.0
* @date 2024-01-10
* Copyright © szhs
*/
@Getter @Setter
@ExcelIgnoreUnannotated
public class RequestPurchaseExportModel extends BaseExcelModel {



    /**
     * 单据编号
     */
    @ExcelProperty(value = "单据编号")
    private String receiptNum;



    /**
     * 行号
     */
    @ExcelProperty(value = "行号")
    private String receiptNumRow;



    /**
     * 请购单状态
     */
    @ExcelProperty(value = "请购单状态")
    private String status;



    /**
     * 业务日期
     */
    @ExcelProperty(value = "业务日期")
    private String businessDate;



    /**
     * 备注
     */
    @ExcelProperty(value = "备注")
    private String remark;



    /**
     * 计划号
     */
    @ExcelProperty(value = "计划号")
    private String planNum;



    /**
     * 料品.料号
     */
    @ExcelProperty(value = "料品.料号")
    private String productNum;



    /**
     * 料品名称
     */
    @ExcelProperty(value = "料品名称")
    private String productName;



    /**
     * 料品规格
     */
    @ExcelProperty(value = "料品规格")
    private String specification;



    /**
     * 品名2
     */
    @ExcelProperty(value = "品名2")
    private String productNameTwo;



    /**
     * 核准采购数量
     */
    @ExcelProperty(value = "核准采购数量")
    private Integer purchaseQuantity;



    /**
     * 累计转PO数量
     */
    @ExcelProperty(value = "累计转PO数量")
    private Integer transferPoNum;



    /**
     * 累计实到数量
     */
    @ExcelProperty(value = "累计实到数量")
    private Integer actualQuantity;



    /**
     * 采购单位
     */
    @ExcelProperty(value = "采购单位")
    private String unit;



    /**
     * 要求交货日期
     */
    @ExcelProperty(value = "要求交货日期")
    private String deliveryDate;



    /**
     * 行状态
     */
    @ExcelProperty(value = "行状态")
    private String rowStatus;

    /**
     * 创建人
     */
    @Length(max = 100, message = "创建人长度应小于100")
    @TableField(fill = FieldFill.INSERT)
    private String createBy;

    /**
     * 审核人
     */
    @ExcelProperty(value = "审核人")
    private String auditor;



    /**
     * 请购单行集合.备注
     */
    @ExcelProperty(value = "请购单行集合.备注")
    private String purchaseRemark;



    /**
     * 需求人员.名称
     */
    @ExcelProperty(value = "需求人员.名称")
    private String requestPersonName;



    /**
     * 审核日期
     */
    @ExcelProperty(value = "审核日期")
    private String auditDate;


}
